A foreign key is a field in a relational table that matches the primary key column of another table.
Foreign Keys are managed on the Foreign Keys tab of the Table Designer. Just simply click on a foreign key field for editing. By using the toolbar below, you can create new, edit and delete the selected foreign key field.
Add Foreign Key
To add a foreign key
- Open the table in the Table Designer.
- Open the Foreign Keys tab.
- Click the
Add Foreign Key from the toolbar.
- Edit foreign key properties.
Edit Foreign Key
To edit a foreign key
- Open the table in the Table Designer.
- Open the Foreign Keys tab.
- Just simply click on the foreign key to edit.
Delete Foreign Key
To delete a foreign key
- Open the table in the Table Designer.
- Open the Foreign Keys tab.
- Click the
Delete Foreign Key from the toolbar.
- Confirm deleting in the dialog window.
See also:
Setting Foreign Key Properties
Related topic:
Foreign Keys Data Selection